home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 17 / Developer Source Volume 17 (I-MODE Publications, Inc.)(2000).iso / orinf / jan97 / aronf108.gif < prev    next >
Graphics Interchange Format  |  1998-02-10  |  27KB  |  288x393  |  4-bit (16 colors)
Labels: text | screenshot | font | number | parallel
OCR: The COMPANY Table Column Data Type Purpose Company_ID NUMBER Primary key COMPANY_PK Narne VARCHAR2 Address VARCHAR2 City VARCHAR2 Nonunique index COMPANYSCITY State VARCHAR2 Nonunique index COMPANYSSTATE VARCHAR2 Parent Company ID NUMBER Nonunique index COMPANYSPARENT Active_Flag CHAR The COMPETITOR Table Column Data Type Purpose Company_ID NUMBER First column of primary key COMPETITOR_PK Product_ID NUMBER Second column of primary key COMPETITOR PK The SALES Table Column Data Type Purpose Company_ID NUMBER First column of primary key SALES_PK Period ID NUMBER Second column of primary key SALES PK Sales_Total NUMBER Figure 8: Our reference tables.